package com.gugu.procedure.dao;

import com.gugu.procedure.bean.Account;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

public interface AccountDao extends JpaRepository<Account, Long>, JpaSpecificationExecutor<Account> {

    @Query(value = "select  *  from  account  where account=?1 and is_del=0", nativeQuery = true)
    Account findTopByAccount(String account);

}
